select * from products where pro_name like '%Spring%dresses%' or pro_des like '%Spring%dresses%'union all select * from products where (pro_name like '%Spring%' or pro_des like '%Spring%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Spring%dresses%' or pro_des not like '%Spring%dresses%')

Fuchsia Strapless Ruffled Organza Beaded Quinceanera Dress

Purple and Leopard Taffeta Dress for Quince with Ruffles

Turquoise Floor-length Ball Gown Ruffled Dress for Quince

2013 Gold Sweet 15 Dresses with Ruffled Organza On Sale

Yellow Green Sweetheart Beaded Quince Dresses with Ruffles

Pretty Spring Green Ruffled Organza Sweet 15 Dresses

Cheap Hot Pink Ruched Organza Ruffed Dress for Quinceaneras

Attractive Red Beaded Ruffled Organza Dress for Quince

Discount Royal Blue Sweetheart Sweet 15 Dress with Ruffles

2013 New Style Purple Ruffled Organza Quinceanera Dresses

Dark Purple Ball Gown Dress for Quince with Ruffles

Blue Sweetheart Organza Ruffled Dress for Quinceaneras

Red Ruffled Organza Beaded Sweetheart Quinceanera Dresses

Aqua Blue Ruched Organza Dress for Quince with Ruffles

Yellow Floor-length Taffeta Pick-ups Dress for Quinceaneras

Green Taffeta Dress for Quince with Appliques and Pick Ups

Brown Taffeta Beaded Sweet Sixteen Dresses with Pick Ups

Two Toned Ruffled Taffeta Quinceanera Dresses with Embroidery

Green Taffeta Pick-ups Dress for Quinceaneras with Appliques

Blue Sweetheart Floor-length Taffeta Beaded Dress for Quince

Light Blue Off The Shoulder Organza Appliques Quince Dresses

Two Toned Taffeta and Tulle Dress for Quince with Pick Ups

Pink Organza Strapless Dress for Quinceaneras with Beading

Purple One Shoulder Appliques Organza Pick-ups Dress for Quince

Black and Red Organza Sweet Sixteen Dresses with Pick Ups

Multi Color Floor Sweetheart Length Quinceanera Dresses

Blue and Black Dress for Quince with Pick-ups and Ruffles

Coral Red and Black Taffeta and Organza Dress for Quince

Olive Green Zebra Taffeta and Organza Layers Dress for Quince

Blue Organza Dress for Quinceaneras with Black Appliques